DBA Data[Home] [Help]

APPS.INV_TRANSACTION_FLOW_PUB dependencies on MTL_TRANSACTION_FLOW_HEADERS

Line 115: mtl_transaction_flow_headers t_hdr

111: t_hdr.new_accounting_flag,
112: t_hdr.qualifier_code,
113: t_hdr.qualifier_value_id
114: FROM
115: mtl_transaction_flow_headers t_hdr
116: WHERE
117: t_hdr.start_org_id = l_start_org_id
118: and t_hdr.end_org_id = l_end_org_id
119: and l_txn_date between t_hdr.start_date and nvl(t_hdr.end_date,l_txn_date+1)

Line 490: mtl_transaction_flow_headers t_hdr,

486: icp.inventory_accrual_account_id,
487: icp.expense_accrual_account_id,
488: icp.intercompany_cogs_account_id
489: FROM
490: mtl_transaction_flow_headers t_hdr,
491: mtl_transaction_flow_lines t_line,
492: mtl_intercompany_parameters icp
493: WHERE
494: t_hdr.header_id = l_header_id

Line 700: mtl_transaction_flow_headers t_hdr

696: t_hdr.new_accounting_flag,
697: t_hdr.Qualifier_Code,
698: t_hdr.Qualifier_Value_Id
699: FROM
700: mtl_transaction_flow_headers t_hdr
701: WHERE
702: t_hdr.start_org_id = l_start_org_id
703: and t_hdr.end_org_id = l_end_org_id
704: and l_txn_date between t_hdr.start_date and nvl(t_hdr.end_date,l_txn_date+1)

Line 1056: SELECT mtl_transaction_flow_headers_s.NEXTVAL

1052: IF fnd_api.to_boolean(p_init_msg_list) THEN
1053: fnd_msg_pub.initialize;
1054: END IF;
1055:
1056: SELECT mtl_transaction_flow_headers_s.NEXTVAL
1057: INTO l_header_id FROM dual;
1058:
1059: l_line_number := 0;
1060:

Line 2323: WHERE EXISTS (SELECT 1 FROM MTL_TRANSACTION_FLOW_HEADERS

2319: nDummy NUMBER;
2320: BEGIN
2321:
2322: SELECT 1 INTO nDummy FROM DUAL
2323: WHERE EXISTS (SELECT 1 FROM MTL_TRANSACTION_FLOW_HEADERS
2324: WHERE START_ORG_ID = p_ship_organization_id
2325: AND END_ORG_ID = p_ship_organization_id
2326: AND (NEW_ACCOUNTING_FLAG = 'Y' OR FLOW_TYPE <> 1));
2327: