You are browsing the archive for Oracle Order Capture.

by oracleguru

Quoting Reports Fact Tables Refresh

ORACLE APPS COMMUNITY > Tutorial > Order Management > Oracle Order Capture

 

NAME: Quoting Reports Fact Tables Refresh
SHORT CODE: ASOFACTREF
MODULE: Oracle Capture

Description: Quoting Reports Fact Tables Refresh
Navigation: Oracle Capture Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_mode : Refresh Mode
  • p_begin_date : Begin Date
  • p_end_date : End Date
  • p_day_offset : Day Bin Offset
  • p_debug_flag : Debug Flag

 

No Comments »

by oracleguru

Order Capture Dependency Generator

ORACLE APPS COMMUNITY > Tutorial > Order Management > Oracle Order Capture

 

NAME: Order Capture Dependency Generator
SHORT CODE: ASODEPGEN
MODULE: Oracle Capture

Description: Generate Order Capture Dependency Engine
Navigation: Oracle Capture Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • P_Database_Object_Name : Database object name for defaulting entity
  • P_Primary_Key_Name : Primary key column name of the entity
  • P_Last_Update_Date_Name : Last update date column name of the entity

 

No Comments »

by oracleguru

Oracle Order Capture Tables

ORACLE APPS COMMUNITY > Tutorial > Order Management > Oracle Order Capture

Oracle Order Capture module data base tables:

  • ASO_APR_APPROVAL_DETAILS
  • ASO_APR_APPROVAL_DET_B
  • ASO_APR_APPROVAL_DET_TL
  • ASO_APR_FUNCTION
  • ASO_APR_OBJ_APPROVALS
  • ASO_APR_RULES
  • ASO_APR_RULES_B
  • ASO_APR_RULES_TL
  • ASO_APR_RULE_APPROVERS
  • ASO_APR_RULE_GROUPS_B
  • ASO_APR_RULE_GROUPS_TL
  • ASO_APR_RULE_GRP_MEMBER
  • ASO_APR_RULE_STEPS_B
  • ASO_APR_RULE_STEPS_TL
  • ASO_BI_LINE_IDS
  • ASO_BI_QUOTE_FACT_JOBS
  • ASO_BI_QUOTE_HDRS_ALL
  • ASO_BI_QUOTE_HDRS_STG
  • ASO_BI_QUOTE_IDS
  • ASO_BI_QUOTE_LINES_ALL
  • ASO_BI_QUOTE_LINES_STG
  • ASO_ER_BIN_RS_FACT
  • ASO_ER_DATA_BIN_FACT
  • ASO_ER_ORD_HDRS_FACT
  • ASO_ER_ORD_LINES_FACT
  • ASO_ER_QTE_HDRS_FACT
  • ASO_ER_QTE_LINES_FACT
  • ASO_ER_REFRESH_LOG
  • ASO_FREIGHT_CHARGES
  • ASO_HEADER_RELATIONSHIPS
  • ASO_LINE_RELATIONSHIPS
  • ASO_PARTY_RELATIONSHIPS
  • ASO_PAYMENTS
  • ASO_PRICE_ADJUSTMENTS
  • ASO_PRICE_ADJ_ATTRIBS
  • ASO_PRICE_ADJ_RELATIONSHIPS
  • ASO_PRICE_ATTRIBUTES
  • ASO_QUOTE_ACCESSES
  • ASO_QUOTE_HEADERS_ALL
  • ASO_QUOTE_LINES_ALL
  • ASO_QUOTE_LINE_ATTRIBS_EXT
  • ASO_QUOTE_LINE_DETAILS
  • ASO_QUOTE_PARTIES
  • ASO_QUOTE_RELATED_OBJECTS
  • ASO_QUOTE_STATUSES_B
  • ASO_QUOTE_STATUSES_TL
  • ASO_QUOTE_STATUS_TRANSITIONS
  • ASO_SALES_CREDITS
  • ASO_SHIPMENTS
  • ASO_SUP_COMPONENT_B
  • ASO_SUP_COMPONENT_TL
  • ASO_SUP_COMP_RESP_MAP
  • ASO_SUP_INSTANCE_VALUE
  • ASO_SUP_RESPONSE_B
  • ASO_SUP_RESPONSE_TL
  • ASO_SUP_SECTION_B
  • ASO_SUP_SECTION_TL
  • ASO_SUP_SECT_COMP_MAP
  • ASO_SUP_TEMPLATE_B
  • ASO_SUP_TEMPLATE_SCOPE
  • ASO_SUP_TEMPLATE_TL
  • ASO_SUP_TMPL_INSTANCE
  • ASO_SUP_TMPL_SECT_MAP
  • ASO_TAX_DETAILS
  • ASO_UPGRADE_ERRORS

Tags: , No Comments »