eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_CL_MISCELLANEOUS dependencies on MSC_SOURCING_TRANSACTIONS

Line 81: lv_sql_stmt_new := ' insert into MSC_SOURCING_TRANSACTIONS( '

77: else
78: lv_sql_stmt_app := ' ';
79: end if;
80:
81: lv_sql_stmt_new := ' insert into MSC_SOURCING_TRANSACTIONS( '
82: ||' INVENTORY_ITEM_ID, '
83: ||' ORGANIZATION_ID, '
84: ||' TRANSACTION_DATE, '
85: ||' TRANSACTION_QTY, '

Line 96: lv_sql_stmt_new := ' insert into MSC_SOURCING_TRANSACTIONS( '

92:
93: execute immediate lv_sql_stmt_new;
94: commit;
95:
96: lv_sql_stmt_new := ' insert into MSC_SOURCING_TRANSACTIONS( '
97: ||' INVENTORY_ITEM_ID, '
98: ||' ORGANIZATION_ID, '
99: ||' SOURCE_ORG_ID, '
100: ||' TRANSACTION_DATE, '

Line 112: lv_sql_stmt_new := ' insert into MSC_SOURCING_TRANSACTIONS( '

108:
109: execute immediate lv_sql_stmt_new;
110: commit;
111:
112: lv_sql_stmt_new := ' insert into MSC_SOURCING_TRANSACTIONS( '
113: ||' INVENTORY_ITEM_ID, '
114: ||' SUPPLIER_ID, '
115: ||' SUPPLIER_SITE_ID, '
116: ||' TRANSACTION_DATE, '

Line 500: from MSC_SOURCING_TRANSACTIONS

496: IF lv_source_type= L_ST_INNER_ORG THEN
497:
498: select GREATEST(NVL(SUM(transaction_qty),0),0)
499: into lv_total_alloc_qty
500: from MSC_SOURCING_TRANSACTIONS
501: where inventory_item_id = arg_sr_item_id
502: and organization_id = arg_org_id
503: and transaction_date > lv_start_date
504: and trunc(transaction_date) <= trunc(arg_end_date)

Line 511: from MSC_SOURCING_TRANSACTIONS

507: ELSIF lv_source_type= L_ST_INTER_ORG THEN
508:
509: select GREATEST(NVL(SUM(transaction_qty),0),0)
510: into lv_total_alloc_qty
511: from MSC_SOURCING_TRANSACTIONS
512: where inventory_item_id = arg_sr_item_id
513: and organization_id = arg_org_id
514: and SOURCE_ORG_ID = arg_source_org
515: and transaction_date > lv_start_date

Line 523: from MSC_SOURCING_TRANSACTIONS

519: ELSIF lv_source_type= L_ST_PO_SUPPLIER THEN
520:
521: select GREATEST(NVL(SUM(transaction_qty),0),0)
522: into lv_total_alloc_qty
523: from MSC_SOURCING_TRANSACTIONS
524: where inventory_item_id = arg_sr_item_id
525: and SUPPLIER_ID = arg_sr_supplier_id
526: and SUPPLIER_SITE_ID = arg_sr_supplier_site_id
527: and transaction_date > lv_start_date