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 105: FROM mtl_material_transactions

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