DBA Data[Home] [Help]

APPS.QA_SOLUTION_DISPOSITION_PKG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 1078: FROM mtl_material_transactions

1074:
1075:
1076: CURSOR mmt_cur (set_id NUMBER) IS
1077: SELECT transaction_id
1078: FROM mtl_material_transactions
1079: WHERE transaction_set_id = set_id;
1080:
1081: CURSOR mti_cur (header_id NUMBER) IS
1082: SELECT transaction_interface_id

Line 1267: mtl_material_transactions_s.nextval,

1263: TRANSACTION_ACTION_ID,
1264: TRANSACTION_SOURCE_TYPE_ID,
1265: TRANSACTION_SOURCE_ID)
1266: VALUES(
1267: mtl_material_transactions_s.nextval,
1268: mtl_material_transactions_s.nextval,
1269: 'QA ACTION: INVSCRAP',
1270: p_collection_id,
1271: p_occurrence,

Line 1268: mtl_material_transactions_s.nextval,

1264: TRANSACTION_SOURCE_TYPE_ID,
1265: TRANSACTION_SOURCE_ID)
1266: VALUES(
1267: mtl_material_transactions_s.nextval,
1268: mtl_material_transactions_s.nextval,
1269: 'QA ACTION: INVSCRAP',
1270: p_collection_id,
1271: p_occurrence,
1272: 1,

Line 1888: FROM mtl_material_transactions

1884: l_reason_id NUMBER;
1885:
1886: CURSOR mmt_cur (set_id NUMBER) IS
1887: SELECT transaction_id
1888: FROM mtl_material_transactions
1889: WHERE transaction_set_id = set_id;
1890:
1891: CURSOR mti_cur (header_id NUMBER) IS
1892: SELECT transaction_interface_id

Line 2114: FROM mtl_material_transactions

2110:
2111:
2112: CURSOR mmt_cur (set_id NUMBER) IS
2113: SELECT transaction_id
2114: FROM mtl_material_transactions
2115: WHERE transaction_set_id = set_id;
2116:
2117: CURSOR mti_cur (header_id NUMBER) IS
2118: SELECT transaction_interface_id

Line 2333: mtl_material_transactions_s.nextval,

2329: WIP_ENTITY_TYPE,
2330: OPERATION_SEQ_NUM,
2331: REASON_ID)
2332: VALUES (
2333: mtl_material_transactions_s.nextval,
2334: mtl_material_transactions_s.nextval,
2335: p_source_code,
2336: p_collection_id,
2337: p_occurrence,

Line 2334: mtl_material_transactions_s.nextval,

2330: OPERATION_SEQ_NUM,
2331: REASON_ID)
2332: VALUES (
2333: mtl_material_transactions_s.nextval,
2334: mtl_material_transactions_s.nextval,
2335: p_source_code,
2336: p_collection_id,
2337: p_occurrence,
2338: 1,

Line 3753: txn_header_id = mtl_material_transactions_s.nextval

3749: -- Update the Dispostion_Status to 'Pending'.
3750:
3751: UPDATE qa_results
3752: SET disposition_status = 'PENDING',
3753: txn_header_id = mtl_material_transactions_s.nextval
3754: WHERE collection_id = p_collection_id AND occurrence = p_occurrence
3755: RETURNING txn_header_id INTO l_txnheader_id;
3756:
3757: -- Calling parent-child pkg to insert History child record for the plan.

Line 3806: SELECT mtl_material_transactions_s.nextval

3802: -- kabalakr.
3803:
3804: /*
3805: CURSOR txn_head_seq IS
3806: SELECT mtl_material_transactions_s.nextval
3807: FROM DUAL;
3808: */
3809:
3810: -- We are not translating the Action_Fired value.

Line 3902: txn_header_id = mtl_material_transactions_s.nextval

3898: wmt_transaction_id = NVL(p_wmt_transaction_id, 0),
3899: rti_interface_transaction_id = NVL(p_rti_interface_transaction_id, 0),
3900: concurrent_request_id = NVL(p_request_id, 0),
3901: eco_name = p_eco_name,
3902: txn_header_id = mtl_material_transactions_s.nextval
3903: WHERE collection_id = p_collection_id
3904: AND occurrence = p_occurrence
3905: RETURNING txn_header_id INTO l_txnheader_id;
3906: