APPS.CST_DRILLDOWN_PUB_PKG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 47: FROM mtl_material_transactions

43: IF (p_event_class_code = 'FOB_SHIP_RECIPIENT_SHIP') OR
44: (p_event_class_code = 'FOB_RCPT_SENDER_RCPT') THEN
45: SELECT organization_id
46: INTO l_security_id_int_1
47: FROM mtl_material_transactions
48: WHERE transaction_id = p_source_id_int_1;
49: ELSE
50: l_security_id_int_1 := p_security_id_int_1;
51: END IF;

Line 102: FROM mtl_material_transactions

98: p_user_interface_type := 'FORM';
99: p_function_name := 'WSM_WSMFJLTX';
100: SELECT source_line_id
101: INTO l_lot_txn_id
102: FROM mtl_material_transactions
103: WHERE transaction_id = p_source_id_int_1;
104: p_parameters := ' FORM_USAGE_MODE="'||pg_FORM_USAGE_MODE||'"'
105: ||' WLT_TXN_ID="' || to_char(l_lot_txn_id)||'"'
106: ||' ORG_ID="'||to_char(p_security_id_int_1)||'"';