DBA Data[Home] [Help]

APPS.QA_SOLUTION_DISPOSITION_PKG dependencies on MTL_MATERIAL_TRANSACTIONS_S

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 2337: mtl_material_transactions_s.nextval,

2333: WIP_ENTITY_TYPE,
2334: OPERATION_SEQ_NUM,
2335: REASON_ID)
2336: VALUES (
2337: mtl_material_transactions_s.nextval,
2338: mtl_material_transactions_s.nextval,
2339: p_source_code,
2340: p_collection_id,
2341: p_occurrence,

Line 2338: mtl_material_transactions_s.nextval,

2334: OPERATION_SEQ_NUM,
2335: REASON_ID)
2336: VALUES (
2337: mtl_material_transactions_s.nextval,
2338: mtl_material_transactions_s.nextval,
2339: p_source_code,
2340: p_collection_id,
2341: p_occurrence,
2342: 1,

Line 3769: txn_header_id = mtl_material_transactions_s.nextval

3765: -- Update the Dispostion_Status to 'Pending'.
3766:
3767: UPDATE qa_results
3768: SET disposition_status = 'PENDING',
3769: txn_header_id = mtl_material_transactions_s.nextval
3770: WHERE collection_id = p_collection_id AND occurrence = p_occurrence
3771: RETURNING txn_header_id INTO l_txnheader_id;
3772:
3773: -- Calling parent-child pkg to insert History child record for the plan.

Line 3822: SELECT mtl_material_transactions_s.nextval

3818: -- kabalakr.
3819:
3820: /*
3821: CURSOR txn_head_seq IS
3822: SELECT mtl_material_transactions_s.nextval
3823: FROM DUAL;
3824: */
3825:
3826: -- We are not translating the Action_Fired value.

Line 3918: txn_header_id = mtl_material_transactions_s.nextval

3914: wmt_transaction_id = NVL(p_wmt_transaction_id, 0),
3915: rti_interface_transaction_id = NVL(p_rti_interface_transaction_id, 0),
3916: concurrent_request_id = NVL(p_request_id, 0),
3917: eco_name = p_eco_name,
3918: txn_header_id = mtl_material_transactions_s.nextval
3919: WHERE collection_id = p_collection_id
3920: AND occurrence = p_occurrence
3921: RETURNING txn_header_id INTO l_txnheader_id;
3922: